﻿CREATE TABLE [Training].[Course] (
    [CourseId]        BIGINT         IDENTITY (1, 1) NOT NULL,
    [SubjectId]       BIGINT         NOT NULL,
    [Location]        NVARCHAR (250) NULL,
    [StartDate]       DATETIME       NOT NULL,
    [EndDate]         DATETIME       NOT NULL,
    [InstructorId]    INT            NOT NULL,
    [MaxParticipants] INT            NOT NULL,
    [State]           NVARCHAR (25)  NOT NULL
);

